/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package neobux;

import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.webui.jsf.component.Button;
import com.sun.webui.jsf.component.Checkbox;
import com.sun.webui.jsf.component.DropDown;
import com.sun.webui.jsf.component.PanelGroup;
import com.sun.webui.jsf.component.StaticText;
import com.sun.webui.jsf.component.TextField;
import com.sun.webui.jsf.model.SingleSelectOptionsList;
import com.sun.webui.jsf.model.Option;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.faces.FacesException;
import javax.faces.context.FacesContext;

/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version AdSettings.java
 * @version Created on Dec 15, 2008, 11:00:23 PM
 * @author Geymen
 */

public class AdSettings extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">
    private int id;
    private String username;
     /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        dropDown1DefaultOptions.setOptions(new com.sun.webui.jsf.model.Option[]{new com.sun.webui.jsf.model.Option("1", "1- Arts & Entertainment"), new com.sun.webui.jsf.model.Option("2", "2- Business & Money"), new com.sun.webui.jsf.model.Option("3", "3- Computers & Internet"), new com.sun.webui.jsf.model.Option("4", "4- Health & Education"), new com.sun.webui.jsf.model.Option("5", "5- Travel & Shopping")});
    }

    private StaticText staticText1 = new StaticText();

    public StaticText getStaticText1() {
        return staticText1;
    }

    public void setStaticText1(StaticText st) {
        this.staticText1 = st;
    }
    private SingleSelectOptionsList adDropDownDefaultOptions = new SingleSelectOptionsList();

    public SingleSelectOptionsList getAdDropDownDefaultOptions() {
        return adDropDownDefaultOptions;
    }

    public void setAdDropDownDefaultOptions(SingleSelectOptionsList ssol) {
        this.adDropDownDefaultOptions = ssol;
    }
    private DropDown adDropDown = new DropDown();

    public DropDown getAdDropDown() {
        return adDropDown;
    }

    public void setAdDropDown(DropDown dd) {
        this.adDropDown = dd;
    }
    private StaticText staticText2 = new StaticText();

    public StaticText getStaticText2() {
        return staticText2;
    }

    public void setStaticText2(StaticText st) {
        this.staticText2 = st;
    }
    private PanelGroup groupPanel1 = new PanelGroup();

    public PanelGroup getGroupPanel1() {
        return groupPanel1;
    }

    public void setGroupPanel1(PanelGroup pg) {
        this.groupPanel1 = pg;
    }
    private TextField textField1 = new TextField();

    public TextField getTextField1() {
        return textField1;
    }

    public void setTextField1(TextField tf) {
        this.textField1 = tf;
    }
    private TextField textField3 = new TextField();

    public TextField getTextField3() {
        return textField3;
    }

    public void setTextField3(TextField tf) {
        this.textField3 = tf;
    }
    private TextField textField2 = new TextField();

    public TextField getTextField2() {
        return textField2;
    }

    public void setTextField2(TextField tf) {
        this.textField2 = tf;
    }
    private Button proceedBtn = new Button();

    public Button getProceedBtn() {
        return proceedBtn;
    }

    public void setProceedBtn(Button b) {
        this.proceedBtn = b;
    }
    private SingleSelectOptionsList dropDown1DefaultOptions = new SingleSelectOptionsList();

    public SingleSelectOptionsList getDropDown1DefaultOptions() {
        return dropDown1DefaultOptions;
    }

    public void setDropDown1DefaultOptions(SingleSelectOptionsList ssol) {
        this.dropDown1DefaultOptions = ssol;
    }
    private DropDown catDropDown = new DropDown();

    public DropDown getCatDropDown() {
        return catDropDown;
    }

    public void setCatDropDown(DropDown dd) {
        this.catDropDown = dd;
    }
    private Checkbox durumChk = new Checkbox();

    public Checkbox getDurumChk() {
        return durumChk;
    }

    public void setDurumChk(Checkbox c) {
        this.durumChk = c;
    }
    private StaticText staticText3 = new StaticText();

    public StaticText getStaticText3() {
        return staticText3;
    }

    public void setStaticText3(StaticText st) {
        this.staticText3 = st;
    }
    // </editor-fold>

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public AdSettings() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     *
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        id = getSessionBean1().getId();

        try {
            Class.forName("org.apache.derby.jdbc.ClientDriver");
            Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/itubux", "itubux", "itubux");
            int i=0,size;
            String query = "SELECT * FROM REKLAM WHERE KUL_ID ="+id;
            String query2 = "SELECT COUNT(ID) AS ADCOUNT FROM REKLAM WHERE KUL_ID ="+id;

           Statement smt = conn.createStatement();
           ResultSet result = smt.executeQuery(query);
           smt=conn.createStatement();
           ResultSet result2= smt.executeQuery(query2);
           if(result2.next())
           {
               Option myOption2;
               size=result2.getInt("ADCOUNT");

               if(size==0)
               {
                   staticText2.setText("You have no advertisement");
                   adDropDown.setVisible(false);
                   proceedBtn.setVisible(false);
                   groupPanel1.setVisible(false);
               }
               else{
                   staticText2.setText("Choose the advertisement below which you want to edit");
                   Option myOptions[]=new Option[size];
                   groupPanel1.setVisible(false);
                   while(result.next()){
                        myOption2=new Option(Integer.toString(result.getInt("ID")),result.getString("ISIM"));
                        myOptions[i]=myOption2;
                        i++;
               }

                adDropDownDefaultOptions.setOptions(myOptions);
           }
          conn.close();
          }
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(AdSettings.class.getName()).log(Level.SEVERE, null, ex);
        }
        catch (SQLException ex) {
            Logger.getLogger(AdSettings.class.getName()).log(Level.SEVERE, null, ex);
        }


        super.init();
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("AdSettings Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }

        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here

    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
        id = getSessionBean1().getId();
        username = getSessionBean1().getUsername();
        staticText1.setText("Logged in as "+username);
        
         if(username.equals(""))
             try{
             FacesContext.getCurrentInstance().getExternalContext().dispatch("Login.jsp");
             }catch(Exception e)
             {
                e.printStackTrace();
             }

        }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {

    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    public String hyperlink1_action() {
        // TODO: Replace with your code
        return "View";
    }

    public String hyperlink2_action() {
        // TODO: Replace with your code
        return "SurfAds";
    }

    public String hyperlink3_action() {
        // TODO: Replace with your code
        return "BuyAds";
    }

    public String hyperlink4_action() {
        // TODO: Replace with your code
        return "RentRef";
    }

    public String hyperlink5_action() {
        // TODO: Replace with your code
        return "Settings";
    }

    public String hyperlink6_action() {
        // TODO: Replace with your code
        return "AdSettings";
    }

    public String hyperlink7_action() {
        // TODO: Replace with your code
        return "DirectRef";
    }

    public String hyperlink8_action() {
        // TODO: Replace with your code
        return "RentedRef";
    }

    public String hyperlink9_action() {
        // TODO: Replace with your code
        return "CashOut";
    }

    public String hyperlink10_action() {
        // TODO: Replace with your code
        return "History";
    }
    /**
     * @return the id
     */
    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String buttonLogout_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        getSessionBean1().destroy();
        return "login";
    }

    public String proceedBtn_action() {
        groupPanel1.setVisible(true);
        staticText2.setVisible(false);
         try {
            Class.forName("org.apache.derby.jdbc.ClientDriver");
            Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/itubux", "itubux", "itubux");
            String adQuery = "SELECT * FROM REKLAM WHERE ID=" + (adDropDown.getSelected().toString());
            Statement smt = conn.createStatement();
            ResultSet result3 = smt.executeQuery(adQuery);

            if(result3.next()){
                    textField1.setText(result3.getString("ISIM"));
                    textField2.setText(result3.getString("URL"));
                    textField3.setText(result3.getString("ACIKLAMA"));
                    catDropDown.setSelected(result3.getString("KATEGORI"));
                    if(result3.getInt("DURUM") == 1)
                        durumChk.setSelectedValue(1);
                    else
                        durumChk.setSelectedValue(0);

            }

            conn.close();
         }catch (ClassNotFoundException ex) {
            Logger.getLogger(AdSettings.class.getName()).log(Level.SEVERE, null, ex);
         }
         catch (SQLException ex) {
            Logger.getLogger(AdSettings.class.getName()).log(Level.SEVERE, null, ex);
         }
         return null;
    }

    public String saveBtn_action() {
        int status = durumChk.isChecked() ? 1 : 0;
        int adID = 0;
        try {
            Class.forName("org.apache.derby.jdbc.ClientDriver");
            Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/itubux", "itubux", "itubux");
            String adQuery = "SELECT * FROM REKLAM WHERE ID="+(adDropDown.getSelected().toString());
            Statement smt = conn.createStatement();
            ResultSet adResult = smt.executeQuery(adQuery);

            if(adResult.next())
                adID = adResult.getInt("ID");

            String adUpdate = "UPDATE REKLAM SET ISIM = '"+textField1.getText().toString().trim()+"', ACIKLAMA = '"+textField3.getText().toString().trim()
                    +"', URL = '"+textField2.getText().toString().trim() + "', KATEGORI = "+Integer.parseInt(catDropDown.getSelected().toString()) + ", DURUM = " +status +
                    " WHERE ID = "+adID;
            smt = conn.createStatement();
            int result = smt.executeUpdate(adUpdate);

            if(result == 1){
                staticText3.setText("Your changes have been saved.");
            }
            conn.close();
         }catch (ClassNotFoundException ex) {
            Logger.getLogger(AdSettings.class.getName()).log(Level.SEVERE, null, ex);
         }
         catch (SQLException ex) {
            Logger.getLogger(AdSettings.class.getName()).log(Level.SEVERE, null, ex);
         }
        return null;
    }


}

